query=
-- _f_propiedades.php listar_propiedades()
SELECT
*
FROM propiedad
WHERE
web = 100 -- std
-- cond_empresa
AND cod_empresa != 0 -- p.
AND (
-- propiedades de empresas no excluidas de MLS
(
(web, cod_empresa) NOT IN (
SELECT web_cap, cod_empresa_cap
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NOT NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE estado = 'X'
)
)
)
-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
-- nop!
AND propiedad.cod_oficina = 0
AND ( cod_empresa != 1 OR 1=2 ) -- ceidemo 1 &&
AND propiedad.cod_propiedad NOT IN (0)
AND (
( propiedad.estado IN ('A','O','B') )
|| ( propiedad.estado IN ('V','R') AND fecha_ult_mod > '20240503' AND NOT 1=2 ) -- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
|| ( propiedad.estado = 'V' AND 0 =1 )
|| ( propiedad.estado = 'R' AND 0 =1 )
|| ( propiedad.estado = '3' AND 0 =1 )
|| ( propiedad.estado = '4' AND 0 =1 )
|| ( propiedad.estado = 'C' AND 0 =1 )
-- || ( propiedad.estado = 'P' AND 1=2 ) -- Prospeccion
|| ( propiedad.estado = 'P' AND 0 =1 )
|| ( propiedad.estado = 'B' AND 0 =1 )
)
AND -- propiedades no publicadas
(
propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
)
AND (
( propiedad.tipo_operacion = '' ) -- El tipo_operacion de la propiedad coincide con el indicado por el usuario
|| ( propiedad.tipo_operacion IN ('V','A') && '' = 'X' ) -- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
|| ( propiedad.tipo_operacion = 'X' && ('' = 'V' || '' = 'A') ) -- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
|| ( '' = '' ) -- El usuario no ha seleccionado tipo_operacion, mostramos todo
-- [20180806d]
|| ( propiedad.tipo_operacion IN ('H') && '' = 'C' ) -- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
)
AND (
cod_valoracion = ''
||
'' = ''
)
-- cond_pais
-- cond_zonas
AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99) )
-- 20180806d
-- cond_metazonas_portales
-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
AND (
( propiedad.metatipo_propiedad = '' ) -- el metatipo_propiedad es el seleccionado
||
( '' = '' )
)
AND (
( propiedad.tipo_propiedad IN (0) ) -- el tipo de propiedad es el seleccionado
||
( ( '0' = '' || '0' = 0 ) ) -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad && tipo_propiedad < 200 ) -- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
||
( ( '0' = '' || '0' = 0 ) && '' = 3 ) -- inversiones
)
AND ( propiedad.superficie >= '' || '' = '' )
AND ( propiedad.superficie <= '' || '' = '' )
AND ( propiedad.superficie_util >= '' || '' = '' )
AND ( propiedad.superficie_util <= '' || '' = '' )
AND ( propiedad.superficie_parcela >= '' || '' = '' )
AND ( propiedad.superficie_parcela <= '' || '' = '' )
AND propiedad.fecha_alta <= '20240518'
AND
( -- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
-- propiedad.tipo_operacion IN ('V','A','X')
( propiedad.precio_pvp <= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_pvp >= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler <= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler >= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
)
-- 20131223 rbz
-- 20130128 rbz
-- 20130916 rbz [20130131a]
-- 20130506 rbz
-- [20160430a]
-- 20131028 rbz [20131028a]
-- 20131220 rbz [20131220a]
-- 20130514 rbz [20130514a]
-- 20180305b
-- [3370-4320]
AND propiedad.num_fotos >= 1
AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas
ORDER BY
CASE
WHEN web = 100 AND cod_empresa = 0 THEN 1 -- propiedades de la propia empresa-
ELSE 9
END,
CASE
WHEN web = 100 AND cod_empresa = 0 THEN prioridad -- propiedades de la propia empresa
-- ELSE 999 -- no deberia ser -1?
ELSE -1
END DESC
, -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
-- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
cod_propiedad DESC -- 11
LIMIT 99999 -- *
-- num_prop_slide= grupo_registros=0 num_max_propiedades_x_pagina=24
OFFSET 0 -- 3 offp
num_tuplas=
13830
JUST IN!
48.000€
Reference:
493972 - 15-34953-18/7832Size:
95m²Plot size:
95m²Bedrooms:
2Bathrooms:
1Built-in cupboards:
YesHeating:
YesAir conditioning:
ColdScale emissions efficiency:
GScale consumption efficiency:
G
JUST IN!
247.000€
Reference:
493914 - 004018Size:
192m²Bedrooms:
4Bathrooms:
2Building year:
2003 (21 year/s)
JUST IN!
750€
(£ 658 app.)
Reference:
493913 - 079574-VSize:
75m²Bedrooms:
2Bathrooms:
1Building year:
2022 (2 year/s)
JUST IN!
620€
(£ 544 app.)
Reference:
493912 - 079576Size:
50m²Bedrooms:
1Bathrooms:
1Building year:
2022 (2 year/s)
JUST IN!
2.000€
(£ 1.755 app.)
Reference:
493911 - 081043Size:
185m²Bathrooms:
1Building year:
1980 (44 year/s)
JUST IN!
2.350.000€
This is an amazing, super-luxury, 4-bed, 3-bath frontline beach home ! It's currently undergoing a top quality renovation, set to finish in Autumn 2024. Situated on Estepona's sought-after New Golden Mile, this apartment represents a great opportunity. With South orientation, it offers 185 sqm of living space and a 38 sqm private terrace with stunning views of the Mediterranean Sea, pool, and lush gardens. The apartment will feature premium finishes, a modern open kitchen with Miele appliances, chic furniture, custom closets, Bang & Olufsen sound system, and an electric fireplace. Plus, you get an underground parking spots and a storage rooms. Located in a very prestigious beachfront complex, known for its breathtaking views, you'll love the amenities. With direct beach access and close to shops, schools, Laguna Village complex, and Estepona town center, this apartment is a "must see"
Reference:
493910Size:
185m²Bedrooms:
4Bathrooms:
3Furnished:
Fully furnishedSwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(38.00m²)Orientation:
South, SouthwestAir conditioning:
ColdNo. of floors:
1Condition:
ExcellentEquipment:
Light, Floor heating (total), Intercom
JUST IN!
330.000€
This refurbished modern apartment on the third floor has beautiful panomaric views to th eMagna Marbella and green gardens and the all the houses around in that very popular area near Puerto Banus.You have 1 doble bedroom and one bathroom, the big luminous living has an open kitchen and a closed terrace with nice views and hugeglass windows.
The apartment has been modernised with completely new furniture and canalisation sistem, electricity,wondows doors and insulation plus new aircon installation.
It has been rented out for short term rentals for several month.
The place is a perfect investment for renals and there are enough m2 to make a second bedroom in those 72m2 inside.You can drie in 5 minutes to Puerto Banus and you could also walk through the beautiful Nueva Andalucia area passing by the casino to Puerto Banus in about 20 minutes.
The restaurants and shops and bars are all at walking distance from this beautiful modernised apartment, you would also have one garaje space included in the price and you can use the comunity pool and garden.
The Malaga airport is at 50 minutes drive from there maximum and you drive to Marbella only 15 minutes.
Reference:
493909Size:
72m²Bedrooms:
1Bathrooms:
1Furnished:
Fully furnishedGarage:
PrivateSwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(6.00m²)Orientation:
SouthAir conditioning:
ColdNo. of floors:
6Condition:
GoodEquipment:
Light
JUST IN!
403.000€
This stunning four-bedroom corner townhouse in Buenavista Mijas boasts breathtaking sea views from every floor. The property spans four floors, providing ample space for comfortable living. The ground floor features a closed garage for two cars, ensuring convenience and security. Residents can enjoy access to a communal swimming pool, perfect for relaxing and soaking up the sun. With its prime location and luxurious amenities, this townhouse offers the ideal opportunity for a peaceful and upscale lifestyle in the beautiful area of Buenavista Mijas.
Reference:
493908Size:
100m²Bedrooms:
4Bathrooms:
4Swimming pool:
ComunitaryFurnished kitchen:
Furnished with appliancesTerraces:
(31.00m²)Orientation:
SouthNo. of floors:
4Condition:
ExcellentEquipment:
Water, Light
JUST IN!
460.000€
Apartment with views of the sea and the marina completely renovated in the center of Fuengirola.
Bright apartment in the heart of Fuengirola next to the marina, less than 5 minutes walk from the Plaza de la Constitución, train and bus station.
Surrounded by shops, restaurants and supermarkets
High profitability.
Completely renovated, 2 bedrooms and 2 bathrooms (1 of them en suite), dressing room, large 13m2 terrace with views of the sea and the marina.
Fully furnished and equipped American kitchen
Optional private garage for €35,000
Reference:
493907Size:
80m²Bedrooms:
2Bathrooms:
2Furnished:
Fully furnishedFurnished kitchen:
Furnished with appliancesTerraces:
(13.00m²)Orientation:
SouthwestNo. of floors:
1Condition:
ExcellentEquipment:
Water, Light, Intercom
JUST IN!
845.000€
Renovated luxury townhouse in Estepona Old Town
Fully renovated and offered key ready, this charming and unique property is located in the heart of old town and historic centre of fashionable Estepona. Fantastic location in a quiet street yet only a few minutes walk to the beach, the new promenade, restaurants and all amenities. Accommodation is over three floors and the townhouse features 3 bedrooms. On the ground floor, entrance level, a spacious and bright open plan living room and dining area with a modern fully equipped kitchen with central island. This level is illuminated with an abundance of natural light from an inner patio that adds Andalucian flavor and charm. The first floor features two very spacious bedrooms and a large patio-oriented bathroom. The third floor features a second bathroom as well as the third bedroom. From here, there is access to a large solarium with pretty views over the old town of Estepona and Bermeja mountain range. Viewings of this luxury key ready townhouse highly recommended.
Reference:
493906Size:
151m²Plot size:
83m²Bedrooms:
3Bathrooms:
2Furnished:
Fully furnishedTerraces:
(33.00m²)Orientation:
NorthwestAir conditioning:
ColdNo. of floors:
3Condition:
ExcellentEquipment:
Floor heating (total)
JUST IN!
1.195.000€
Are you looking for the ultimate panoramic sea view?
Undisturbed and uninterrupted! - It doesn't get any better than this:
In Marbella, you will find this dream of a house with 180º panoramic sea views as far as Gibraltar and Africa. Located in Elviria, very well known and popular for its super fine sandy beaches.
The location is "first line" so to speak, south facing and just behind a large nature reserve, allowing for this outstanding and unbelievably wide sea view that will remain yours forever. In this very luxurious and modernly renovated terraced house with 5 bedrooms and 3.5 bathrooms, you simply cannot escape the sea views.
The entrance level of the three storey house welcomes you to a large and open plan living area with a lounge corner/fireplace, dining room and lounge, as well as an open plan kitchen with cooking island. If you are preparing food in the kitchen, you can see the sea; if you are eating in the lounge or dining room, you can still see it, even from the lounge with the fireplace. There is no way to escape this magnificent view all the way to Morocco.
A beautiful south-facing terrace has another lounge and dining area and is the perfect place to enjoy the Andalucian sun all year round.
One floor below this main living area is a spacious master bedroom suite with en-suite bathroom and beautiful walk-in wardrobes. A further bedroom, gym and entertainment area are also on this level. Again, all the rooms on this level have incredible views.
Upstairs there are three further bedrooms - all with stunning views.
The house is tastefully designed in a Scandinavian style. A large open staircase connects the floors perfectly.
It has electric blinds in the bedrooms, air conditioning hot/cold and underfloor heating throughout. The property comes complete with underground parking and storage.
The property is surrounded by verdant green gardens, there is a community pool with lounge chairs.
The location of the house is ideally situated in a gated community, between nature and "life" - you are only a few minutes drive from the buzzing commercial centre of Elviria, with an array of shops, restaurants and bars - and the fantastic white beaches that can only be found in Elviria.
This is a very special property that rarely comes on the market.
Reference:
493905Size:
338m²Bedrooms:
5Bathrooms:
5Furnished:
Fully furnishedSwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesOrientation:
SouthAir conditioning:
ColdNo. of floors:
3Condition:
ExcellentEquipment:
Floor heating (total), Chimney, Intercom
JUST IN!
1.690.000€
PRICE REDUCED!!! Beautiful villa situated within the urbanisation of Monte Mayor, in the hills between Marbella, Benahavis and Estepona. South facing with very good views. Driveway with courtyard entrance, leading to a gallery distributed into living/dining room with vaulted ceiling, large covered terrace, kitchen with island and breakfast area and four bedrooms. On the lower floor is 155M2 of garage, a self contained apartment with its own entrance, kitchenette and there could be a further 2 bedrooms and a bodega in this area. Magnificent pool area with a gazebo chill-out area. Underfloor heating, A/C, Heat pump, etc. etc.
Detached Villa, Benahavís, Costa del Sol.
6 Bedrooms, 5.5 Bathrooms, Built 650 m², Garden/Plot 2800 m².
Orientation : South.
Pool : Private.
Views : Sea, Mountain, Country, Panoramic.
Kitchen : Fully Fitted.
Parking : Garage, More Than One.
Reference:
493904 - MM B19Size:
872m²Plot size:
2.892m²Bedrooms:
6Bathrooms:
5Garage:
PrivateSwimming pool:
PrivateGarden:
Comunitary Furnished kitchen:
Furnished with appliancesOrientation:
SouthNo. of floors:
2
JUST IN!
1.200.000€
A great Opporunity in charming Benahavís Town Villa with awesome Panoramic Views.
Discover a charming Andalusian villa with LIFT in Benahavís, one of the most prestigious areas of the Costa del Sol.
Nestled in a secure gated community with 24hr security, it seamlessly blends traditional charm with modern interiors and more than 580m2 built.
Surrounded by spectacular views of nature, sea and mountains, it offers serene living close to city comforts of a place like Benahavis, on the Costa del Sol.
It has spacious rooms and high ceilings and each area is designed to make the most of the abundant natural light.
The villa consists of three bedrooms, each with an en suite bathroom and a private terrace, and is thoughtfully equipped with a convenient lift for easy access to different levels.
The lower level hosts a large lounge area, two living rooms with terraces and a nice kitchen and dining area that enjoys the stunning panoramic views.
The spacious living room on the lower floor offers direct access to a large terrace with a pool area where you can enjoy the amazing sunsets.
Its proximity to shops, bars and restaurants, golf courses, and the beach make this property a very special place to reside all year round or in the summer months being in a privileged location.
With just a 2 minutes drive to Benahavis, 15-minute drive to the beach, 20 minutes to Puerto Banùs and 25 minutes to Marbella and Estepona, you get access to the vibrant lifestyle and amenities these iconic destinations have to offer.
For those traveling, Málaga Airport is only 45 minutes away, ensuring ease of access for both residents and visitors. If you are looking for a new property that offers a Mediterranean lifestyle and tranquillity, this villa is waiting for you.
The prestigious area around Benahavis boasts one of the most scenic landscapes to the west of the Costa del Sol; offering remarkable and picturesque views and more than ten golf courses, the mixture of sun, sea, golf and mountains make this charming abode a very special place to reside.
Established in the area are some of the most exclusive mansion clubs in Europe, which contribute to the Benahavis' status as the richest municipality per capital in Andalucía.
Its quaint white washed village is considered to be the gastronomic capital of Andalucía and is home to some of the finest restaurants found anywhere in southern Spain.
Spread across the beautiful countryside between the golden beaches of Marbella, Estepona and the spectacular mountains of Ronda, there is an excellent selection of modern apartments, penthouses and exclusive villas on the frontline golf and with panoramic views to the sea. The swift access to the coastal road makes commuting a pleasure and brings together a harmonious blend of comfortable, modern living with a natural Mediterranean environment.
Note: The community fee €696 includes 24-hour security, maintenance of the common areas and gardens of the complex, weekly maintenance of the pool and private gardens of the villa, fiber optic internet, etc....
Please do not hesitate to contact us
Reference:
493903Size:
584m²Plot size:
135m²Bedrooms:
3Bathrooms:
5Garage:
PrivateSwimming pool:
PrivateGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(167.00m²)Orientation:
SouthAir conditioning:
ColdNo. of floors:
3Condition:
ExcellentEquipment:
Floor heating (total), Chimney
JUST IN!
266.500€
Discover your ideal home in the La Calerita area in Fuengirola! This charming 2-bedroom, 2-bathroom home offers you comfort and style in a quiet and peaceful setting. Enjoy the community pool while you relax in your new home. In addition, you will be next to the new La Loma Park, perfect for walking and enjoying nature. Don't miss this unique opportunity and contact us today to arrange a visit! The abbreviated information document is available to you. Expenses: Taxes (ITP or VAT+AJD) + Notarial and registration expenses. RSR
Reference:
493902 - 6372-RSRSize:
96m²Bedrooms:
2Bathrooms:
2Furnished:
Partially furnishedSwimming pool:
ComunitaryTerraces:
(6.00m²)Air conditioning:
ColdNo. of floors:
1Condition:
ExcellentEquipment:
Intercom
JUST IN!
1.228.000€
Welcome to a fantastic investment opportunity in a prime location, just a stroll from Calle Larios and Calle Carretería. This multi-unit building spans 212 m² and features 2 renovated apartments and 2 renovated studios, each offering excellent rental income potential.
On the ground and first floors, you'll find modern studios with open-plan living areas and fully equipped kitchens. The second floor hosts a spacious one-bedroom apartment, ideal for couples or singles. The third floor boasts a two-bedroom duplex with generous living spaces and multiple bathrooms, perfect for families. Another highlight is the balconies facing the street, ideal for enjoying a pleasant evening.
The building comes with a tourist license, making it ready for short-term rentals. Its prime location ensures easy access to shops, cafes, restaurants, and public transportation. This property is a fantastic investment with strong rental potential.
Contact us to schedule a viewing today.
Reference:
493901 - SPCRM1194Size:
212m²Bedrooms:
5Bathrooms:
4Furnished:
Fully furnishedAir conditioning:
ColdNo. of floors:
1
JUST IN!
1.450.000€
Discover this investment gem featuring a 255 m² building with three renovated apartments and one office space, all designed for comfort. This property offers a perfect blend of residential and commercial use, making it an excellent investment with strong rental potential. Located in the heart of Centro Historico, just steps away from the popular Calle Larios.
The ground floor boasts a commercial space ideal for a variety of businesses, ensuring visibility and accessibility. On the first and second floors, you'll find one-bedroom apartments, each thoughtfully designed for comfort and convenience. The third floor features a spacious two-bedroom apartment, perfect for families or larger groups.
All units come with balconies that provide charming views of the beautiful street, enhancing the living experience. Located in a prime area with everything close by, residents and tenants will enjoy easy access to shops, cafes, restaurants, and public transportation.
The building comes with a tourist license, making it ready for short-term rentals and ensuring a steady income stream. Don't miss out on this fantastic investment opportunity.
Contact us today to schedule a viewing!
Reference:
493900 - SPCRM1193Size:
255m²Bedrooms:
4Bathrooms:
3Air conditioning:
ColdNo. of floors:
1
JUST IN!
414.000€
Charming 3-storey semi-detached house in a gated community in El Lagarejo.
On the ground floor, the property has a toilet, a renovated American kitchen with a window that overlooks the living room, which has a fireplace and air conditioning. From the living room you have access to a fantastic porch, the community gardens and the pool, creating an ideal space for leisure and relaxation.
On the first floor, you will find three bedrooms with built-in wardrobes and two full bathrooms, one of them en suite. One of the rooms includes a small office, while the master bedroom is air-conditioned and has a balcony offering open mountain views.
The attic houses a bright room with large windows on both sides and a smaller additional room. The house is equipped with gas central heating.
The property includes two parking spaces, one covered and one uncovered, located right in front of the main door of the house. The urbanization, made up of only 8 neighbors, has large gardens, providing an exclusive and quiet environment. Next to the pool, there is a barbecue area with tables and chairs, perfect for enjoying outdoor gatherings.
Don't miss the opportunity to visit this charming semi-detached house and discover all its advantages.
Reference:
493899 - SPCRM1127Size:
155m²Bedrooms:
3Bathrooms:
2Air conditioning:
ColdNo. of floors:
1
JUST IN!
950.000€
Welcome to this fantastic apartment in the exclusive urbanization Aldea Blanca in Nueva Andalucia - a gem on the Spanish coast!
When you step through the door, you are greeted by generous and open spaces, created for social moments and community. The open kitchen is a true dream for those who love to cook and at the same time be part of the conversation. The slatted windows permeate the entire apartment with the warm Andalusian light, creating an atmosphere of charm and elegance.
Further into the home opens up the spacious living room and dining area, perfect for dinners and relaxed evenings with friends and family. From here you can easily get out to the impressive terrace that stretches to the southwest. On this terrace, with a panoramic view of the glittering sea and, on a clear view, even the mountain of Gibraltar, every moment becomes a pleasure.
When night falls and it's time to retire, an oasis of relaxation awaits. A large bathroom, complete with bathtub, offers the opportunity to pamper yourself with long relaxing baths. The two guest bedrooms are spacious and have built-in wardrobes for convenient storage.
The bedroom for the owner of the house is a private retreat with its own bathroom and an exclusive direct access to the terrace. Here you can wake up to the sun's rays and the sound of the sea, which creates a perfect start to each day.
This apartment is not just a residence, but a lifestyle. Aldea Blanca offers not only an exclusive address but also community amenities such as gardens, pools and proximity to the best that Nueva Andalucia has to offer. Discover a new level of living in this wonderf ul apartment - your dream home awaits!
Reference:
493898 - 733-01011PSize:
151m²Bedrooms:
3Bathrooms:
3Furnished:
Fully furnishedGarage:
ComunitarySwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(17.00m²)Orientation:
SouthwestAir conditioning:
ColdNo. of floors:
1Condition:
GoodEquipment:
Chimney
JUST IN!
1.075.000€
Fantastic penthouse in the sought-after area of Higueron West. The apartment has large, lovely rooms and features a super spacious living room with a beautiful open kitchen offering a wonderful view from all sides. Additionally, there are terraces on both sides with access from the living room and kitchen. There is also an enclosed laundry room next to the kitchen. A large master bedroom with a lovely modern bathroom and plenty of closets. The second bedroom is also spacious and has its own bathroom. Furthermore, there are two parking spaces under the building right next to the entrance and a nice storage room. The homeowners' association offers the most beautiful areas and pools. The large popular sports center is very close, offering padel tennis, fitness, and much more. Truly an apartment that must be seen
Reference:
493897 - 5128Size:
133m²Bedrooms:
2Bathrooms:
2Swimming pool:
ComunitaryGarden:
Comunitary Terraces:
(85.00m²)Air conditioning:
Cold-heatNo. of floors:
1
JUST IN!
540.000€
Welcome to this charming property! Let us introduce you to this delightful boutique hotel, located 30 km from the coast of Torre del Mar and 15 km from La Viñuela. It offers the perfect balance between nature, tranquility, and luxurious comfort. Ideal for spiritual retreats, corporate events, and hosting various gatherings. The estate comprises 5 enchanting buildings. The main building spans 2 floors, featuring a reception area, a cozy lounge with a bar, a small restaurant, and a fully equipped kitchen on the ground floor. The hotel boasts 6 independent rooms, each equipped with high-quality amenities and materials, all with private bathrooms and air conditioning. Five of these rooms are located on the upper floor, with one on the ground floor, making it ideal for guests with mobility issues. In a separate building, there are two apartments measuring 35 and 45 m2 respectively, with the option to add 3 additional rooms. The surrounding gardens and terraces offer stunning views of Comares, the Sierras de Tejeda, Almijara, and Alhama. Additionally, the property features a spa and a private fitness area in a separate building, along with a pool. There are also multiple storage rooms and a covered garage. All facilities are no more than 3 years old, equipped with modern, silent air conditioning units for both warm and cold temperatures. The house features underfloor heating with room-by-room control via thermostat. The liquid gas heating boiler has its own tank. There is a water storage tank with a capacity of 1,000 liters. The fitness area and spa are heated by radiators and boilers. The electrical system is equipped with separate control panels for each floor and outbuilding. Satellite telephony and internet access are also available. We are pleased to be able to present this dream property to you soon, either personally or via virtual viewing. Because this world, it is unique - just like our Axarquía. In Andalusia. On the Costa del Sol. Here, on the sunny side of life...
Reference:
493896 - 5986Size:
834m²Plot size:
6.933m²Bedrooms:
8Bathrooms:
7Furnished:
Fully furnishedGarage:
PrivateSwimming pool:
PrivateGarden:
Comunitary Orientation:
SouthAir conditioning:
ColdNo. of floors:
1Condition:
Good
JUST IN!
599.000€
impressive detached villa, with 327 built meters (227 of them useful) and pre-installation of lift to communicate its 3 floors, is located in a privileged location with panoramic sea views. Situated in a residential area with no vehicular traffic, this property offers tranquillity and privacy.
Currently distributed in 2 double bedrooms, 2 huge bathrooms, a spacious living room and a separate kitchen, this villa also has a welcoming room on the ground floor and a pedestrian access. With 2667 metres of plot, this property offers endless possibilities. It is in a raw state, which gives you the opportunity to adapt it to your needs.
There is also the possibility to create 2 additional bedrooms with two more bathrooms, or to reform it to include a storage room and a covered 3 car garage, with additional space for 3 more vehicles on the slope. This house has a unique personality and extraordinary potential.
Further highlighting its attributes, the dining area has a skylight that offers immense potential to create a truly special space.
Please do not hesitate to contact me for more information on this incredible property.
Reference:
493895Size:
320m²Plot size:
2.363m²Bedrooms:
2Bathrooms:
2Furnished:
Fully furnishedFurnished kitchen:
Furnished with appliancesTerraces:
(100.00m²)Orientation:
East, Southeast, South, SouthwestNo. of floors:
3Condition:
GoodEquipment:
Phone line, Light, ChimneySecurity measures:
Alarm
JUST IN!
350.500€
This spectacular penthouse in Las Lagunas is simply incomparable.
With a south orientation that ensures wonderful luminosity, this jewel has four cosy bedrooms and two elegant bathrooms.
The separate kitchen, which also has a utility room and the possibility of integrating it into the spacious living room, is perfect for those who love cooking.
As you enter, you will be greeted by a spacious entrance hall with a practical wardrobe.
The imposing living room, adorned with a cosy fireplace, invites you to spend unforgettable moments with your loved ones.
But what is really captivating is the huge terrace of approximately 60 square metres, equipped with an awning that will allow you to enjoy it at any time of the day.
It has the advantage of a solar panel system, which guarantees a sustainable and efficient supply, as well as a water tank that ensures a constant supply.
In addition, there is a wooden shed for multiple uses, and a barbecue area that promises unforgettable encounters.
This place is definitely a dream come true!
Reference:
493894Size:
90m²Bedrooms:
4Bathrooms:
2Furnished:
Partially furnishedTerraces:
(58.00m²)Orientation:
East, Southeast, South, Southwest, WestAir conditioning:
ColdNo. of floors:
5Condition:
GoodEquipment:
Phone line, Water, Light, Chimney, IntercomSecurity measures:
Alarm
JUST IN!
1.495.000€
VILLA WITH ATTRACTIVE AND BEAUTIFUL MEDITERRANEAN CHARACTER, DISTRIBUTED ON A COMFORTABLE GROUND FLOOR AND LOCATED ON THE FIRST LINE OF GOLF, OF THE PRETIGIOUS REAL CLUB DE GOLF DE GUADALMINA. Located in a corner, in a cul de sac, next to the 18th hole of the south course. Enjoy a beautiful mature garden, very well maintained, with a multitude of trees and plants. LOCATED, 2 km from San Pedro de Alcántara and 6 km from Puerto Banús. Estepona and Marbella 15 min. Restaurants, Shops, and Leisure Areas just a 10-minute walk away and the beach a 5-minute drive away. Completely surrounded by Golf Courses and just a 3-minute walk from the golf clubhouse. (Golf share optional). Enjoy complete tranquility and privacy. South facing with great light and relaxing views of its excellently maintained mature garden and pool. It has a parking area for 2 cars at the entrance of the house plus a closed garage. In good condition and magnificently built, this property is distributed on a very comfortable single level. With a living room with high ceilings with wooden beams and direct access to the porch, garden and the kidney-shaped pool. The master bedroom en-suite with dressing room and direct access to the garden. A large and very bright kitchen with also high beamed ceilings and a dining area located next to the access to the parking area. The other good size bedrooms share 2 full bathrooms. The home has the option of separating an apartment by a door. From the cozy solarium enjoy relaxing views of the garden, golf courses and mountains. It is also provided with a large semi-basement with access from outside the house that could be used as a gym, games room, etc. It has great possibilities to change its distribution. We highly recommend visiting this fantastic property.
Reference:
493893Size:
252m²Plot size:
993m²Bedrooms:
5Bathrooms:
3Garage:
PrivateSwimming pool:
PrivateGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(100.00m²)Orientation:
Southeast, South, SouthwestAir conditioning:
ColdNo. of floors:
1Condition:
ExcellentEquipment:
Phone line, Safe box, Water, Light, Gas, ChimneySecurity measures:
Alarm
JUST IN!
549.000€
Located just 20 min drive from the airport.
You find this amazing townhouse with 4 bedrooms and 2 bathrooms with a huge terrace of 140 m2 and a smaller terrace 12m2 with sunset and views to the mountains.
In the entrance you find one bedroom and bathroom, downstairs you find a living room and seperate dining room and kitchen, you have direct access to the terrace from the kitchen and living room. A few steps further down you find another room around 18 m2 with many possibilities with a window.
Upstairs you find the master bedroom with ensuite bathroom, with nice open views, on the same level you find 2 other bedrooms. Further up you find a laundry room with access to another terrace and the terrace with sunset.
Gated area with swimmingpool, 1 parking space. and storeroom in the entrance.
Close to all amenities, 500 meters to the nearest supermarked, 2,5 km to the beach and center of Fuengirola, just a short drive to Mijas Golf, El Chaparral Golf.
Keys in office, easy viewing
Reference:
493892Size:
171m²Bedrooms:
4Bathrooms:
2Furnished:
Fully furnishedSwimming pool:
ComunitaryFurnished kitchen:
Furnished with appliancesTerraces:
(150.00m²)Orientation:
Southeast, WestAir conditioning:
Cold-heatNo. of floors:
3Condition:
GoodEquipment:
LightNew properties
Would you like to receive by email the properties we include in the website?
Selected: 13830 propertiesnext »